 
 
 
 
 
					  
/* Power Concentration and Bottom-up Information Flow  */
/*  Wenhui Yang          				  */
/* 	Dec, 2022                        				  */



 clear
graph drop _all
set matsize 5000
set more off

	
	
	

************************************************************************************************
***Appendix
************************************************************************************************

	

	
	
***************************************
***Table A2 source of dual appointment
***************************************


use "legislature_202209.dta",clear

	
	sort prefid year
    xtset prefid year

	
xi:logit concentration  l.protestall  countypool i.year ,  cluster(provid)
	eststo 
xi:logit concentration  l.protestall countypool ethnicarea calender   i.year ,  cluster(provid)
	eststo 
xi:logit concentration  l.protestall countypool ethnicarea calender logpopulation logrevenue logpgdp   urbanrate i.year ,  cluster(provid)
	eststo
xi:logit concentration  l.protestall countypool ethnicarea calender logpopulation logrevenue logpgdp   urbanrate age gender ethnic edu_graduate homecity i.year ,  cluster(provid)
	eststo 
esttab,   keep(logpopulation logrevenue logpgdp L.protestall countypool ethnicarea calender urbanrate age gender ethnic edu_graduate homecity) se(3) b(3) star(* .1 ** .05 *** .01) tex pr2
    eststo clear



	

	
***************************************
***Table A3 log outcome variable
***************************************

use "legislature_202209.dta",clear


xtreg logproposal concentration i.year,fe cluster(prefid)
	eststo 
xtreg logproposal concentration age tenure gender ethnic edu_graduate homecity i.year,fe cluster(prefid)
	 eststo 
xtreg logproposal concentration age tenure gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender protestall i.year,fe cluster(prefid)
	 eststo 
xtreg  logperproposal concentration i.year,fe cluster(prefid)
	eststo 
xtreg  logperproposal concentration age tenure gender ethnic edu_graduate homecity i.year,fe cluster(prefid)
	eststo 
xtreg  logperproposal concentration age tenure gender ethnic edu_graduate homecity logpopulation logrevenue logpgdp calender protestall i.year,fe cluster(prefid)
	eststo 
esttab,   keep(concentration age tenure gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender protestall) se(3) b(3) star(* .1 ** .05 *** .01) tex r2
    eststo clear
	
	
	
	
***************************************
***Table A4 full results
**************************************

use "legislature_202209.dta",clear

	
	sort prefid year
    xtset prefid year

xtreg proposal concentration i.year,fe cluster(prefid)
	eststo 
xtreg proposal concentration age tenure gender ethnic edu_graduate homecity i.year,fe cluster(prefid)
	 eststo 
xtreg proposal concentration age tenure gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender protestall i.year,fe cluster(prefid)
	 eststo 
xtreg perproposal concentration i.year,fe cluster(prefid)
	eststo 
xtreg perproposal concentration age tenure gender ethnic edu_graduate homecity i.year,fe cluster(prefid)
	eststo 
xtreg perproposal concentration age tenure gender ethnic edu_graduate homecity logpopulation logrevenue logpgdp calender protestall i.year,fe cluster(prefid)
	eststo 
esttab,   keep(concentration age tenure gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender protestall) se(3) b(3) star(* .1 ** .05 *** .01) tex r2
    eststo clear
	


	
***************************************
**Table A5 robustness check: add one by one
***************************************

use "legislature_202209.dta",clear


xtreg proposal concentration i.year,fe cluster(prefid)
	eststo 
xtreg proposal concentration age  i.year,fe cluster(prefid)
	 eststo 
xtreg proposal concentration age tenure  i.year,fe cluster(prefid)
	 eststo 
xtreg proposal concentration age tenure gender  i.year,fe cluster(prefid)
	 eststo 
xtreg proposal concentration age tenure gender ethnic  i.year,fe cluster(prefid)
	 eststo 
xtreg proposal concentration age tenure gender ethnic edu_graduate  i.year,fe cluster(prefid)
	 eststo 
xtreg proposal concentration age tenure gender ethnic edu_graduate homecity i.year,fe cluster(prefid)
	 eststo 
xtreg proposal concentration age tenure gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender protestall i.year,fe cluster(prefid)
	 eststo 

esttab,   keep(concentration age tenure gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender protestall) se(3) b(3) star(* .1 ** .05 *** .01) tex r2
    eststo clear
	
	
	
	
***************************************
**Table A6: multiple imputed data
***************************************
**

 foreach x of num 1/10{ 
use "leg`x'",clear
 tab year, generate(year)  
save "leg`x'",replace
 } 
 
  
  
  


clear

miest leg xtreg proposal concentration year1 year2 year3 year4 year5 year6 year7 year8 year9 year10 year11,fe nsets(10) iout 

miest leg xtreg proposal concentration age  year1 year2 year3 year4 year5 year6 year7 year8 year9 year10 year11,fe nsets(10) iout 

miest leg xtreg proposal concentration age tenure  year1 year2 year3 year4 year5 year6 year7 year8 year9 year10 year11,fe nsets(10) iout 

miest leg xtreg proposal concentration age tenure gender  year1 year2 year3 year4 year5 year6 year7 year8 year9 year10 year11,fe nsets(10) iout 

miest leg xtreg proposal concentration age tenure gender ethnic  year1 year2 year3 year4 year5 year6 year7 year8 year9 year10 year11,fe nsets(10) iout 

miest leg xtreg proposal concentration age tenure gender ethnic edu_graduate  year1 year2 year3 year4 year5 year6 year7 year8 year9 year10 year11,fe nsets(10) iout 

miest leg xtreg proposal concentration age tenure gender ethnic edu_graduate homecity year1 year2 year3 year4 year5 year6 year7 year8 year9 year10 year11,fe nsets(10) iout 

miest leg xtreg proposal concentration age tenure gender ethnic edu_graduate homecity logpopulation logrevenue logpgdp calender protestall year1 year2 year3 year4 year5 year6 year7 year8 year9 year10 year11,fe nsets(10) iout 




	***************************************
***	Table A7  power centration and Proposal, lagged one year
***************************************


use "legislature_202209.dta",clear


xtreg proposal l.concentration i.year,fe cluster(prefid)
	eststo 
xtreg proposal l.concentration age tenure gender ethnic edu_graduate homecity i.year,fe cluster(prefid)
	 eststo 
xtreg proposal l.concentration age tenure gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender protestall i.year,fe cluster(prefid)
	 eststo 
xtreg  perproposal l.concentration i.year,fe cluster(prefid)
	eststo 
xtreg  perproposal l.concentration age tenure gender ethnic edu_graduate homecity i.year,fe cluster(prefid)
	eststo 
xtreg  perproposal l.concentration age tenure gender ethnic edu_graduate homecity logpopulation logrevenue logpgdp calender protestall i.year,fe cluster(prefid)
	eststo 
esttab,   keep(L.concentration age tenure gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender protestall) se(3) b(3) star(* .1 ** .05 *** .01) tex r2
    eststo clear
	
	
	


	
***************************************
***	Table A8 robustness check: exclude ethnic regions
***************************************


use "legislature_202209.dta",clear


xtreg logproposal concentration i.year if ethnicarea==0,fe cluster(prefid)
	eststo 
xtreg logproposal concentration age tenure gender ethnic edu_graduate homecity i.year if ethnicarea==0,fe cluster(prefid)
	 eststo 
xtreg logproposal concentration age tenure gender ethnic edu_graduate homecity logpopulation logrevenue logpgdp calender protestall i.year if ethnicarea==0,fe cluster(prefid)
	 eststo 
xtreg  logperproposal concentration i.year if ethnicarea==0,fe cluster(prefid)
	eststo 
xtreg  logperproposal concentration age tenure gender ethnic edu_graduate homecity i.year if ethnicarea==0,fe cluster(prefid)
	eststo 
xtreg  logperproposal concentration age tenure gender ethnic edu_graduate homecity logpopulation logrevenue logpgdp calender protestall i.year if ethnicarea==0,fe cluster(prefid)
	eststo 
esttab,   keep(concentration age tenure gender ethnic edu_graduate homecity logpopulation logrevenue logpgdp calender protestall) se(3) b(3) star(* .1 ** .05 *** .01) tex r2
    eststo clear
	
	
	
	
	
	
	
	
	

***************************************
***Table A9	robustness check: exclude vice provincial cities,clear
***************************************

use "legislature_202209.dta",clear



xtreg logproposal concentration i.year if viceprovince==0,fe cluster(prefid)
	eststo 
xtreg logproposal concentration age tenure gender ethnic edu_graduate homecity  i.year if viceprovince==0,fe cluster(prefid)
	 eststo 
xtreg logproposal concentration age tenure gender ethnic edu_graduate homecity logpopulation logrevenue logpgdp calender protestall i.year if viceprovince==0,fe cluster(prefid)
	 eststo 
xtreg  logperproposal concentration i.year if viceprovince==0,fe cluster(prefid)
	eststo 
xtreg  logperproposal concentration age tenure gender ethnic edu_graduate homecity i.year if viceprovince==0,fe cluster(prefid)
	eststo 
xtreg  logperproposal concentration age tenure gender ethnic  edu_graduate homecity logpopulation logrevenue logpgdp calender protestall i.year if viceprovince==0,fe cluster(prefid)
	eststo 
esttab,   keep(concentration age tenure gender ethnic edu_graduate homecity logpopulation logrevenue logpgdp calender protestall) se(3) b(3) star(* .1 ** .05 *** .01) tex r2
    eststo clear
	
		
	
	
	

***************************************
***Table A10 robustness check: cluster at province level
***************************************
use "legislature_202209.dta",clear

xtreg proposal concentration i.year,fe cluster(provid)
	eststo 
xtreg proposal concentration age tenure gender ethnic edu_graduate homecity i.year,fe cluster(provid)
	 eststo 
xtreg proposal concentration age tenure gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender protestall i.year,fe cluster(provid)
	 eststo 
xtreg proposal concentration age tenure gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender protestall i.year i.provid,fe cluster(provid)
	 eststo 
xtreg  perproposal concentration i.year,fe cluster(provid)
	eststo 
xtreg  perproposal concentration age tenure gender ethnic edu_graduate homecity i.year,fe cluster(provid)
	eststo 
xtreg  perproposal concentration age tenure gender ethnic edu_graduate homecity logpopulation logrevenue logpgdp calender protestall i.year,fe cluster(provid)
	eststo 
xtreg  perproposal concentration age tenure gender ethnic edu_graduate homecity logpopulation logrevenue logpgdp calender protestall i.year i.provid,fe cluster(provid)
	eststo 
esttab,   keep(concentration age tenure gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender protestall) se(3) b(3) star(* .1 ** .05 *** .01) tex r2
    eststo clear
	
	
	
	
	
	
	
	
	

***************************************
***Table A11 individual level analysis
***************************************

	
	
  
  use "delegate_202212.dta",clear
  
  
    reg all_proposal  dual_city    if congresslevel==2,r
    eststo
   reg all_proposal  dual_city  gender age official shool_yr year_congress localyears   if congresslevel==2,r
    eststo
   reg all_proposal  dual_city  gender age official shool_yr year_congress localyears logpgdp_city logprevenue_city  if congresslevel==2,r
    eststo
   reg suggestionsperyear  dual_city    if congresslevel==2,r
    eststo
   reg suggestionsperyear  dual_city  gender age official shool_yr year_congress localyears   if congresslevel==2,r
    eststo
   reg suggestionsperyear  dual_city  gender age official shool_yr year_congress localyears logpgdp_city logprevenue_city  if congresslevel==2,r
    eststo
    reg motionsperyear  dual_city    if congresslevel==2,r
    eststo
   reg motionsperyear  dual_city  gender age official shool_yr year_congress localyears   if congresslevel==2,r
    eststo
   reg  motionsperyear dual_city  gender age official shool_yr year_congress localyears logpgdp_city logprevenue_city  if congresslevel==2,r
    eststo
    esttab, se(3) b(3) star(* .1 ** .05 *** .01) tex r2
    eststo clear
	
	
	

***************************************
***Table A12 Interaction of dual appointment and occupation types
***************************************

	
	
  
  use "delegate_202212.dta",clear
  
  
	**interaction
	
	/*
	foreach x of varlist villageofficial  militarypolice official teacher leader farmer worker entrepreneur getihu manager clerk  skilled {
		gen dual_`x'=dual_city*`x' 
	}
	*/
	
	
	
	foreach x of varlist  villageofficial  militarypolice official teacher leader farmer worker entrepreneur getihu manager clerk  skilled {
		reg all_proposal  dual_city `x' dual_`x'  gender age  shool_yr year_congress localyears logpgdp_city logprevenue_city  if congresslevel==2
	   eststo
	}
  esttab, drop(_cons  gender age  shool_yr year_congress localyears logpgdp_city logprevenue_city) se(3) b(3) star(* .1 ** .05 *** .01) r2 tex
    eststo clear

	
	
	

***************************************
***	Table A13 power centration and appoint
***************************************
use "legislature_202209.dta",clear




xtreg appoint concentration age gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender protestall i.year if tenure==1,fe cluster(prefid)
	eststo 
xtreg appoint concentration age gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender  protestall i.year if tenure==2,fe cluster(prefid)
	eststo 
xtreg appoint concentration age gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender  protestall i.year if tenure==3,fe cluster(prefid)
	eststo 
xtreg appoint concentration age gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender  protestall i.year if tenure==4,fe cluster(prefid)
	eststo 
xtreg appoint concentration age gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp calender  protestall i.year if tenure==5,fe cluster(prefid)
	eststo 

esttab,   keep(concentration age gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp  calender  protestall) se(3) b(3) star(* .1 ** .05 *** .01) tex r2
    eststo clear
	
	
	
	
	
	
***************************************
***	Table A14 
***************************************
use "legislature_202209.dta",clear


xtreg proposal yesman concentration post  i.year,fe cluster(prefid)
	eststo 
xtreg proposal yesman  concentration post age gender ethnic edu_graduate homecity i.year,fe cluster(prefid)
	 eststo 
xtreg proposal  yesman concentration post  age  gender ethnic edu_graduate  homecity logpopulation logrevenue logpgdp protestall i.year,fe cluster(prefid)
	 eststo 
xtreg perproposal yesman  concentration post i.year,fe cluster(prefid)
	eststo 
xtreg perproposal  yesman concentration post  age gender ethnic edu_graduate homecity i.year,fe cluster(prefid)
	eststo 
xtreg perproposal yesman  concentration post age gender ethnic edu_graduate homecity logpopulation logrevenue logpgdp protestall i.year,fe cluster(prefid)
	eststo 
esttab, keep(concentration post yesman age gender ethnic edu_graduate homecity logpopulation logrevenue logpgdp protestall)  se(3) b(3) star(* .1 ** .05 *** .01) r2 tex
    eststo clear	
	
	

	

	
	
	


	
	

	
	
	